from openpyxl import load_workbook
import os

loder_path = os.path.join("data")
data_list = {}

for filename in os.listdir(loder_path):
    file_path = os.path.join(loder_path, filename)
    items_list = {}
    wb = load_workbook(file_path)
    for name in wb.sheetnames:
        sheet = wb[name]
        print(sheet)
        a = 0
        for row in sheet.iter_rows(min_row=2):
            cell = row[3]
            a += cell.value
        items_list[name] = a
    new_name = filename.split(".")[0]
    data_list[new_name] = items_list
print(data_list)
